import xlrd,xlwt
import datetime

def readXls():
    workbook = xlrd.open_workbook_xls(r'../test.xls')#use path of workbook
    print(workbook.sheet_names())
    sheet1 = workbook.sheet_by_name("Sheet1")
    print(sheet1.name)
    nrows = sheet1.nrows
    ncols = sheet1.ncols
    print(nrows,ncols)
    printTime(sheet1.cell_value(1,5))


def printTime(dateValue):
    date_tuple = xlrd.xldate_as_tuple(dateValue, 0)
    date = datetime.time(*date_tuple[3:])
    print(date)

if __name__ == '__main__':
    readXls()